Filtering Data Items

The following example demonstrates how to filter the data items displayed in a grid using the Filter event. Only the data items whose ShipVia property value is "3" will be displayed in the grid.

XAML	Copy Code
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="cvs_orders" Source="{Binding Source={x:Static Application.Current}, Path=Orders}" Filter="ShipViaFilter"/> </Grid.Resources> <xcdg:DataGridControl x:Name="OrdersGrid" ItemsSource="{Binding Source={StaticResource cvs_orders}}"/> </Grid>

XAML

Copy Code

<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid">

  <Grid.Resources>

    <xcdg:DataGridCollectionViewSource x:Key="cvs_orders"

                                       Source="{Binding Source={x:Static Application.Current},

                                                        Path=Orders}"

                                       Filter="ShipViaFilter"/>

  </Grid.Resources>

  <xcdg:DataGridControl x:Name="OrdersGrid"

                        ItemsSource="{Binding Source={StaticResource cvs_orders}}"/>

</Grid>

The following code provides the implementation of the ShipViaFilter event. This code should be placed in the "code-behind" of your XAML page.

VB.NET	Copy Code
Private Sub ShipViaFilter( sender As Object, e As FilterEventArgs ) Dim value As Object = CType( e.Item, System.Data.DataRow )( "ShipVia" ) If( Not value Is Nothing ) And ( Not value Is DBNull.Value ) Then If CInt( value ) = 3 Then e.Accepted = True Else e.Accepted = False End If End If End Sub

VB.NET

Copy Code

Private Sub ShipViaFilter( sender As Object, e As FilterEventArgs )

  Dim value As Object = CType( e.Item, System.Data.DataRow )( "ShipVia" )

  If( Not value Is Nothing ) And ( Not value Is DBNull.Value ) Then

    If CInt( value ) = 3 Then

      e.Accepted = True

    Else

      e.Accepted = False

    End If

  End If

End Sub

C#	Copy Code
private void ShipViaFilter( object sender, FilterEventArgs e ) { object value = ( ( System.Data.DataRow )e.Item )[ "ShipVia" ]; if( ( value != null ) && ( value != DBNull.Value ) ) { if( ( int )value == 3 ) { e.Accepted = true; } else { e.Accepted = false; } } }

Copy Code

private void ShipViaFilter( object sender, FilterEventArgs e )

{

  object value = ( ( System.Data.DataRow )e.Item )[ "ShipVia" ]; 

  if( ( value != null ) && ( value != DBNull.Value ) )

  {

    if( ( int )value == 3 )

    {

     e.Accepted = true;

    }

    else

    {

     e.Accepted = false;

    }

  }   

}

The next example demonstrates how to filter data items using the Filter predicate delegate.

VB.NET	Copy Code
Dim view As New DataGridCollectionView( Orders ) view.Filter = New Predicate(Of Object)( ShipViaFilter ) dataGridControl.ItemsSource = view Private Function ShipViaFilter( item As Object ) As Boolean Dim value As Object = TryCast( item, System.Data.DataRow )( "ShipVia" ) If( Not value Is Nothing ) And ( value <> DBNull.Value )Then If CInt( value ) == 3 Then Return True End If End If Return false End Function

VB.NET

Copy Code

Dim view As New DataGridCollectionView( Orders )

view.Filter = New Predicate(Of Object)( ShipViaFilter )

dataGridControl.ItemsSource = view

Private Function ShipViaFilter( item As Object ) As Boolean

   Dim value As Object = TryCast( item, System.Data.DataRow )( "ShipVia" )

   If( Not value Is Nothing ) And ( value <> DBNull.Value )Then

     If CInt( value ) == 3 Then

       Return True

     End If

   End If

   Return false

End Function

C#	Copy Code
DataGridCollectionView view = new DataGridCollectionView( Orders ); view.Filter = new Predicate<object>( ShipViaFilter ); dataGridControl.ItemsSource = view; private bool ShipViaFilter( object item ) { object value = ( ( System.Data.DataRow )item )[ "ShipVia" ]; if( ( value != null ) && ( value != DBNull.Value ) ) { if( ( int )value == 3 ) return true; } return false; }

Copy Code

DataGridCollectionView view = new DataGridCollectionView( Orders );

view.Filter = new Predicate<object>( ShipViaFilter );

dataGridControl.ItemsSource = view;



private bool ShipViaFilter( object item )

{

  object value = ( ( System.Data.DataRow )item )[ "ShipVia" ];

  if( ( value != null ) && ( value != DBNull.Value ) )

  {

    if( ( int )value == 3 )       

      return true;       

  }

  return false;

}